Name | Type | Length | IsNullable | Collation |
CustomerID | nchar | 10 | SQL_Latin1_General_CP1_CI_AS | |
CompanyName | nvarchar | 80 | SQL_Latin1_General_CP1_CI_AS | |
CompanyName | sysname | 80 | SQL_Latin1_General_CP1_CI_AS | |
City | nvarchar | 30 | SQL_Latin1_General_CP1_CI_AS | |
City | sysname | 30 | SQL_Latin1_General_CP1_CI_AS | |
Country | nvarchar | 30 | SQL_Latin1_General_CP1_CI_AS | |
Country | sysname | 30 | SQL_Latin1_General_CP1_CI_AS |
create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'